/*
 * Sonatype Nexus (TM) Open Source Version
 * Copyright (c) 2008-present Sonatype, Inc.
 * All rights reserved. Includes the third-party code listed at http://links.sonatype.com/products/nexus/oss/attributions.
 *
 * This program and the accompanying materials are made available under the terms of the Eclipse Public License Version 1.0,
 * which accompanies this distribution and is available at http://www.eclipse.org/legal/epl-v10.html.
 *
 * Sonatype Nexus (TM) Professional Version is available from Sonatype, Inc. "Sonatype" and "Sonatype Nexus" are trademarks
 * of Sonatype, Inc. Apache Maven is a trademark of the Apache Software Foundation. M2eclipse is a trademark of the
 * Eclipse Foundation. All other trademarks are the property of their respective owners.
 */
package org.sonatype.nexus.quartz.internal.datastore;

import java.util.List;

import org.sonatype.nexus.datastore.api.DataAccess;

import org.apache.ibatis.annotations.Param;

public interface QuartzTestDAO
    extends DataAccess
{
  List<String> tables();

  List<String> primaryKeys();

  List<String> foreignKeys();

  List<String> indexes();

  Integer expectedIndexes();

  /**
   * Get column type from information schema
   *
   * @param tableName  table that column belongs to
   * @param columnName column witch type needs to be received
   * @return return the type of specified column
   */
  String getTableColumnType(@Param("table_name") String tableName, @Param("column_name") String columnName);

  String getColumnCharacterLimit(@Param("table_name") String tableName, @Param("column_name") String columnName);
}
